SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002001s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598897 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598897 [ RunTime:0.002573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546902,232103,491312,208426,286986,104115,752164,741174,400928,176644,241972,276143,866714,801179,818722,156710,243131,518726,563630,699285,104519,793833,81902,431849,705392,438868,535750,356626,80313,260974,365842,874429,93027,983778,832337,1047877,744222,516184,946911,464866,41648,452523,839012,252377,329994,800932,980931,817277,29404,208778,300629,55577,723676,836841,275043,41127,272963,231818,652713,633639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001812s ]