SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019759 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019759 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734400,1045729,480573,443068,203641,809436,10952,528584,840414,643161,255624,577448,1048104,147079,701505,575994,506737,798979,589895,374597,790059,116740,603643,491541,321886,607983,946719,844979,11527,474543,371247,249128,848438,44896,83384,46339,560517,370824,588670,838160,269039,685375,606571,772957,497066,338386,340310,500819,360935,636700,477257,202840,173331,19684,195907,920673,677732,225406,911114,66025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019759 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019759 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]