SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415405 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415405 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (202476,909021,911775,496375,482306,740154,543178,327522,580554,505914,500797,840989,690317,510300,359062,535852,465671,440020,748094,23854,125930,804492,224296,657932,142105,212736,910814,937385,457317,264137,156625,613266,98147,40856,277378,220995,827004,499133,690935,696721,653048,255046,788303,29557,296272,730171,418969,918790,707116,602945,597314,989718,689841,512485,836691,682424,596118,488726,862840,413611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]