SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310117 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310117 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191677,779676,161580,340597,857326,470077,409200,928385,319292,526715,473831,489451,17234,521637,381198,1035384,553925,480862,307869,334967,302791,181780,649932,1016220,312271,960270,809099,154446,307896,530422,541478,924751,602427,904835,586789,164824,1013544,107986,450327,960212,375080,550405,348187,173196,286453,620459,215574,140824,890536,864849,334916,838592,888479,194862,549828,661635,5773,639355,203891,1010534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001394s ]