SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004661s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535112 LIMIT 1 [ RunTime:0.003034s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535112 [ RunTime:0.002934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044593,457403,1030121,402669,948182,410098,689508,95448,919735,611368,403149,871511,846540,820970,77778,815636,719296,322459,905303,502309,285475,333355,377858,70258,1010867,558518,104730,11745,866889,220632,489966,619151,46297,1000105,774219,837455,992885,133894,404841,496252,431820,669213,272746,249391,903297,993273,725825,709896,718843,852890,568460,817060,1010587,1027064,143941,314776,824669,197545,224148,94780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]