SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 891680 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 891680 [ RunTime:0.003985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453847,667431,1007717,897890,570322,73354,844696,1037553,336031,546543,634482,801029,949949,533587,38388,868774,384464,309960,518042,591306,1033428,413116,588476,982053,134054,541380,527001,951461,174300,604372,1006952,998712,200031,988316,579952,1021522,993508,267515,102060,626333,332598,598437,498691,834701,836854,970837,89285,525683,866247,653221,357890,736894,505389,74843,703185,626331,383542,230707,409919,1015421) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 891680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 891680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]