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` = 420143 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420143 [ RunTime:0.001530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515639,849502,516598,491949,42440,1000398,1037216,246556,11166,828718,675242,981451,862731,915565,722858,263517,267010,271115,518817,744513,915851,356683,690059,451219,856227,16992,896265,294964,265261,866683,358222,254928,531407,584322,720897,106453,909483,762897,682763,268218,657280,246763,957962,369723,683119,988413,8301,783386,955967,603244,545449,955499,883505,1004839,477827,1044772,702892,56169,9978,215835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000833s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000826s ]