SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293043 LIMIT 1 [ RunTime:0.000830s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293043 [ RunTime:0.002225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166586,706524,238113,779015,335806,256691,64657,290262,583441,1037362,759327,914225,976096,103585,510740,1009844,655214,922011,612499,902402,487971,111658,580383,648149,51770,787550,334387,608394,319378,814378,589628,341352,1038829,222215,579605,225141,498120,7027,262134,350479,1025278,729311,1011359,109177,904184,859143,285893,758320,793872,399362,218149,319061,406258,203941,452898,269617,921631,311428,653015,682157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001692s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002160s ]