SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416923 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416923 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453661,398266,439852,1026249,775300,325558,823989,940770,352220,623679,803782,499856,98056,392067,623491,872132,127569,917699,177823,1005385,991352,1038362,473136,852811,969593,341224,43941,1043930,504862,896988,954079,351867,420257,382608,310931,280920,414544,569414,136654,213090,1000829,1016889,567875,339402,999801,905498,939713,418256,722409,877314,612077,45446,793969,55746,447269,571196,44316,1029632,98931,176603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002815s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]