SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538451 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538451 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (22233,455487,692409,17834,849465,403317,502689,808677,714994,11703,337103,779906,10572,714417,779517,600230,731806,39116,717655,182113,519293,79654,976942,750229,120941,518306,476132,251797,519027,859473,11049,983143,107801,798162,369429,945419,149025,680552,51120,132312,511543,586779,657397,597866,1015443,261287,370671,731495,891130,206038,221631,331621,846248,341591,18502,672810,507767,338840,918678,847723) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]