SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840681 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840681 [ RunTime:0.001891s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (135804,784373,89883,87045,463328,426243,990093,354769,181753,504957,742569,571617,53901,104010,75934,907047,838543,975827,746145,520178,979385,615886,984414,279678,459709,915648,125136,663022,434111,353286,495885,417757,848896,1013044,658202,1019163,1013026,393344,204941,582969,1033669,717722,710718,603769,266288,327174,121942,777327,465792,368560,981002,849923,1012528,715572,543725,116741,150820,99446,64760,313629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001727s ]