SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10461 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10461 [ RunTime:0.002451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033073,68272,448107,527083,742822,788725,499454,99675,259436,63094,529079,655632,57364,340254,250265,587120,766189,708839,121554,606262,236229,479105,892095,3843,1035553,61687,455761,610172,463607,294480,166428,476724,227017,36728,68480,689076,890283,66921,246751,32057,372,226182,364061,463050,948590,657691,383154,44143,668754,456568,161539,289029,671007,331490,486736,764022,22244,71954,641673,427962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001239s ]