SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596706 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596706 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022727,601334,249042,662506,89480,1035822,1007561,168772,553919,514638,190990,770922,596383,740783,325906,579041,786112,796715,234670,249348,913608,561752,209370,260374,110405,687657,345650,135426,618317,453706,864749,953031,262947,855380,326731,297306,190899,896689,66081,477492,472595,490676,551100,887706,223788,946813,75942,48658,649064,324181,886994,1026468,982591,532991,230831,709665,466996,217015,576522,525453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]