SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54198 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54198 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897489,824871,1016817,1043822,745957,692644,692920,748460,260217,153124,588203,616564,649149,940682,273810,103610,499799,374289,391911,910000,535407,607039,1014210,685673,283855,256183,189968,109830,213700,689988,623587,396133,831636,402005,1030741,646748,901190,300559,426155,31669,600452,920321,798297,877866,293128,239917,363863,509434,397850,148514,27765,266882,442450,172211,902726,106580,305457,573577,571966,885773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]