SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021739 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021739 [ RunTime:0.002820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86942,1028135,157882,319258,174414,666218,883865,1013730,99702,635146,825751,56438,807353,531967,871840,945671,696284,910678,271831,744650,409785,889451,495547,217574,885687,52623,782850,381601,832443,508292,851396,547630,274368,585712,1026149,320956,606429,965391,125531,384907,152715,721952,725979,490701,814036,165675,665801,470387,801560,946706,800771,786665,1030859,62736,635035,1004645,742140,264604,600979,958128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]