SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413461 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413461 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884175,374358,678385,387773,327958,659689,483916,17977,76223,537090,131418,432956,470334,746574,892144,654408,779180,919824,38781,220312,104029,133077,836684,303004,620054,92165,995185,605920,204325,904813,361788,741834,368401,818741,1826,524127,898183,692758,1040460,28349,211738,607684,134885,952538,965054,868668,994026,734995,114625,648926,406306,192789,677732,55719,986246,409324,900186,158522,705874,12724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]