SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583823 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583823 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (265016,246689,291034,622154,728969,252940,860663,999679,288647,508279,759996,858890,26638,398377,696607,247538,889771,92435,599449,827238,503478,200064,345143,125851,818230,912698,139750,12034,74810,513545,14357,395294,94541,468994,649925,249473,553535,66010,239840,643906,156958,385699,454200,65926,263535,393043,680297,978500,604873,838069,677127,964816,777810,892993,46949,526891,873992,984746,310495,76969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]