SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509248 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509248 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025781,691039,829560,413052,301353,46036,336253,600810,422596,217233,368082,743649,366091,908365,203609,470105,291913,115847,255235,699477,382737,657087,83442,231068,530694,54431,664461,767917,831610,734237,90466,463703,310978,954804,483167,648289,346471,1028185,232336,897809,186769,180649,761475,682896,953707,141650,413862,744765,1032522,351138,107217,774867,385818,838823,897108,103446,45803,86102,502089,1020272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509248 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509248 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]