SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425740 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425740 [ RunTime:0.003009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761020,522269,441753,631535,138271,419394,405060,666220,272185,30454,185191,355488,218657,180088,870862,504541,814678,738566,740992,1041761,879462,1017411,254823,450198,703142,377580,186568,941716,436793,1042285,73456,449354,806464,986370,13162,640128,128217,24048,722215,356382,901946,89382,586186,160135,318031,228430,992821,58374,423272,658931,127836,832234,236914,964229,925056,71082,324915,568062,242468,826449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001247s ]