SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003874s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34385 LIMIT 1 [ RunTime:0.001032s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34385 [ RunTime:0.003665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199500,1045825,715775,68206,896519,1016293,487156,481839,940292,767385,199052,192686,726401,7187,293438,902886,923796,1001586,95580,336282,9744,533846,886052,71562,1031909,91690,1037353,456810,1003967,675986,1042324,26184,1043494,462228,59380,884453,719783,285866,835160,737658,180287,864966,445360,569695,572006,546092,484614,552497,277099,338774,24603,746702,524559,821806,864119,436665,777491,591078,290681,220744) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34385 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34385 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]