SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487341 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487341 [ RunTime:0.002612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480309,617315,223092,567407,526200,172966,592160,648266,616584,96057,931181,74986,374913,605882,774154,89010,304139,563180,355893,95490,729933,387447,387652,639600,667063,584181,151513,518662,552942,40075,480983,442861,892951,361400,1043990,156012,920107,616585,666645,266889,119371,550472,985610,1023158,709793,395235,498886,139224,52828,210349,998258,561947,198298,147039,39306,345197,406664,92054,755338,414930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]