SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522181 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522181 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009748,669518,921574,636789,484690,626234,68845,47120,546583,964544,397703,935213,284782,261496,996954,685288,378606,162976,141319,362848,804715,96779,352652,344936,571941,464965,534234,864778,478368,447956,242196,293720,1037102,959658,129240,638918,356498,338330,551660,268739,383140,258229,57706,120261,662748,137292,282205,531127,805825,260700,175712,747038,1039943,759889,788937,133173,269051,584854,136026,1023573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]