SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003808s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500141 LIMIT 1 [ RunTime:0.000516s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500141 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452134,832816,892213,354425,579975,243482,646513,922816,470035,230509,482082,483686,695282,968563,274179,168752,1010625,180079,592688,559168,760652,717777,478418,150093,228984,714368,206412,528194,54823,336676,78691,793387,717679,337113,649490,768247,85171,804648,935632,906476,254004,596383,18454,208608,500790,623653,4862,937435,734287,1030767,646061,546056,72608,1008246,237783,347132,776189,129505,869143,545355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]