SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509520 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509520 [ RunTime:0.002919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802969,212512,840582,962111,84909,162162,558121,829414,295305,244455,458910,827518,967760,101671,377978,315150,563129,967660,205891,828922,241940,789369,291460,292848,722474,879936,858,166384,877778,522981,492335,24500,187152,423895,954157,1008608,573736,985681,480515,239627,609551,246637,628696,174670,167476,602330,172399,854756,72581,586737,882646,904328,820209,523171,838459,743331,878919,1048216,844927,239516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]