SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542791 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542791 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948868,657642,94779,295835,1024007,390580,982647,473283,524101,906452,195959,662316,974955,352795,8015,937352,216547,25096,409444,1038204,476946,745342,696013,638835,624865,582665,368466,238081,535385,457289,1025130,952157,769132,638561,723795,759296,186132,549615,463919,702706,251796,319707,380668,424361,404361,819729,509023,511690,413568,490724,202743,431385,576257,398402,864785,264715,597018,271565,682370,542023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]