SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806418 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806418 [ RunTime:0.002478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426203,479618,638562,981351,482261,478018,789259,311641,145980,993050,41562,235140,264256,99552,595189,981510,517577,304327,657881,432818,735986,647341,325019,331876,248207,601748,1015835,134719,479209,159314,999571,301836,74819,27272,893013,202535,1017878,286954,855828,647192,426324,46234,774153,409556,661157,196518,77693,688711,64540,580572,565044,702841,771004,414129,522844,618383,479883,205612,758933,532165) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001716s ]