SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480956 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480956 [ RunTime:0.002070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492898,188312,726211,890214,429502,52890,884865,757659,663834,79535,783055,560913,499650,910616,248824,882578,965424,623693,360400,253435,197229,907834,204430,671694,38057,164505,221180,645500,695875,1047329,74209,54909,325345,313057,62390,359954,175440,614402,799019,686895,1010273,242073,645499,568966,808381,344484,631861,654810,311889,130891,439198,211508,632170,462523,771409,487195,725081,485787,644581,325584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]