SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255022 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255022 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846998,295237,6970,23517,81941,499881,328547,477470,619580,621761,757742,156435,1027337,122604,967207,831933,35092,845956,449845,694635,722087,753987,955358,792001,418037,193986,187883,199687,440801,799599,1038267,63057,927912,577599,191766,145206,967713,258246,446451,886544,312393,442633,331362,282585,62740,798670,465429,830176,839518,1025470,998958,16199,802843,747047,564823,5121,939469,1036026,997782,546414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]