SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001512s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427311 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427311 [ RunTime:0.002577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474237,345148,390618,1028102,521075,1046444,865313,552552,680114,398934,78672,363329,192858,646985,820503,692217,1015463,188287,367321,580020,427350,900834,795165,279074,989942,618819,953493,402929,898439,90381,732771,999443,610744,261053,91175,589488,169806,988059,726307,44897,1036409,416371,43201,250326,431299,280089,15577,934940,88882,272507,196295,71657,570041,1026685,561893,893459,1000831,418853,888152,676713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001625s ]