SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002748s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428807 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428807 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745563,500934,479340,388799,29088,229652,1042120,213306,459843,103865,264758,770297,464563,937235,624664,926573,6161,798380,65184,977260,374933,249657,327310,666368,165040,940406,449097,832445,101562,106351,909958,438781,116127,904390,304186,265150,145080,697717,332890,386218,262420,838508,610777,1038584,884802,770286,388577,138629,1004555,793932,834654,976522,354002,769961,1015170,939783,684194,933469,1037732,220214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]