SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001923s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420841 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420841 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733555,856967,3906,78817,619041,877706,915777,965492,612984,108871,495021,688279,321465,71707,350424,874888,949142,127674,1016477,22873,1014842,81678,760292,581238,813948,576289,264237,145143,587233,395370,178694,270942,932595,404652,821603,28193,742258,655072,746978,920797,123653,516538,589062,299240,284070,461542,712523,919457,489331,1012957,93452,274645,46834,713628,144863,314188,99979,499779,554216,109939) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]