SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042940 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042940 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300299,1044128,897677,526376,114983,887649,452170,54589,600842,571688,201456,597916,291150,914699,503813,87058,373458,38818,992572,179855,587463,1040962,537437,368668,417963,81840,1015489,52900,6763,911093,22894,847159,654035,239164,235642,385142,819540,41403,732281,735368,400741,304781,969212,731088,845515,366503,64034,770748,510385,958386,1025148,743877,809866,9447,601881,449609,729404,734712,843995,139910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]