SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046657 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046657 [ RunTime:0.002479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37702,531080,711252,731992,806799,174342,216816,725614,511843,764161,683313,1033916,218931,384521,734953,867930,838903,183807,1003939,969201,1008959,298652,1022851,487817,208330,600204,636887,252603,86533,858002,169188,553308,617210,236336,176280,239155,796709,371280,364271,714988,153931,146655,312833,735751,641008,478861,585509,923051,351987,511732,184438,985532,756063,85502,577084,235050,644128,461362,922756,710999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046657 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046657 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001274s ]