SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438522 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438522 [ RunTime:0.002765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514173,13124,222363,281894,66066,636570,205411,453810,227545,1030697,710543,38737,536678,207847,497934,540677,916199,691157,803997,17180,675980,864723,287491,413219,955212,822039,430773,660812,1015899,937994,535921,435789,503466,944574,267103,608243,440486,202753,361400,473966,586881,1031687,207702,552906,379237,197416,733230,915620,926759,677347,743826,203394,833205,105414,476342,223716,916301,410929,607396,588482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]