SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 608010 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 608010 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683385,927468,194233,58282,862962,792340,624921,541969,708052,628355,288904,497774,700835,217092,205895,821383,4705,193590,1012425,711020,470790,494850,425143,601450,9914,327146,4829,793040,470381,968131,388044,50808,984218,382221,683497,743380,690676,473117,153299,546390,917173,579315,8648,1006607,200979,921455,616545,209138,285585,316035,921038,938977,220138,308799,968056,952974,321592,757630,124892,765782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 608010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 608010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]