SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284312 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284312 [ RunTime:0.004741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254702,233228,125621,1002675,674398,452057,780958,232676,469519,973016,438900,325051,998076,38938,937541,548025,228887,484175,548136,222255,64430,70261,1037637,174066,243797,366360,807659,943940,253039,1025975,739510,137855,832517,34214,1034220,567268,1038210,481263,449644,386633,617243,485341,60273,7439,184347,205738,774461,371893,232705,769925,334527,161585,931640,1038133,139771,783232,601024,881242,478551,510398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003777s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000985s ]