SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567031 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567031 [ RunTime:0.002302s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753567,38783,486581,310780,1017931,770344,421524,920697,253358,1003617,381466,108760,104007,767897,901997,349488,387407,17641,43371,56841,868208,359867,17952,970109,215366,798526,57460,392190,539597,977669,50661,350680,430114,448041,28977,895876,245664,691380,932887,798643,374499,11194,327128,992426,702349,524282,871451,136334,741267,331543,524110,799271,186207,530196,577582,758530,657830,942201,466109,216195) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]