SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335313 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335313 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (983141,546089,153720,1018830,419642,705266,645998,8298,416449,642085,715984,583141,451440,207021,368381,933962,686879,779273,15852,641013,446866,952045,429826,399494,16787,124387,230404,1000524,473546,284657,345138,267867,557226,441957,517890,537748,405406,292832,112743,807301,309324,559585,87858,690844,138195,320980,477962,334617,165036,303501,182881,460322,70599,1025009,400482,840936,647687,20591,1019403,628577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002478s ]