SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481654 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481654 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857853,1043103,280589,648437,176948,970948,833515,581531,38597,654072,227600,772637,456809,163341,744756,59924,771455,127212,137946,878573,1003337,363940,746126,566671,778040,407806,534743,94716,741542,756127,910270,681786,152051,941041,766413,50391,712379,732204,450463,463927,2141,855724,913072,236513,873717,460237,540417,166350,901910,655778,1023946,518454,749831,539844,205394,703190,486537,785974,454985,959637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001908s ]