SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456613 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456613 [ RunTime:0.002338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150465,496293,975055,434923,517963,944040,286238,402427,95204,137065,742134,1035282,525492,216758,927300,634560,479582,981123,109732,917579,461031,53605,575496,188836,39210,239772,101996,295171,518629,189849,154354,139983,15524,465075,709114,871862,377723,647160,325028,508337,492915,940221,213914,1021597,410203,405662,801039,348661,450779,418099,178273,392751,17303,247511,716684,982696,329876,733238,980826,441825) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]