SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814928 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814928 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329626,406970,519718,439711,818884,1048290,318858,39595,639765,210837,408768,107997,60889,40763,981299,221685,172237,643036,729605,538775,394848,950539,436125,1044248,123098,350680,404703,460031,309061,58328,271822,727868,253462,280303,404112,267494,11417,323548,754163,321351,561971,902484,326674,535836,1042469,555348,70218,784284,10016,925924,697157,696772,228946,523875,265702,790299,623130,1048641,142827,50872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]