SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002831s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505625 LIMIT 1 [ RunTime:0.002618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505625 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656400,203505,436919,658789,426311,793204,272416,84445,58883,874192,724111,328116,177729,310365,186039,243944,881377,107073,369313,118435,390689,1012098,208174,309741,284365,761131,421060,4285,776941,722933,331869,680191,853180,244557,601531,753055,343319,618274,417670,488042,870461,133652,906085,511832,1034557,988258,298169,381226,320176,987118,44185,261773,818209,631510,371454,570658,1045247,958532,102879,755294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505625 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505625 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000975s ]