SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809401 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809401 [ RunTime:0.001982s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154515,926386,528699,431641,732439,768295,428020,792896,227754,91553,534403,299113,10746,40389,870249,552716,241648,682987,48946,989137,641773,995221,1023807,817283,627256,566016,660335,842452,413522,294587,888067,494741,973599,32514,288533,82561,479988,637273,62274,88124,803009,48212,926777,901526,130174,714319,97959,737179,214198,732964,893178,917835,486569,517883,184546,232503,44327,198742,111843,166544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]