SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559241 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559241 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334898,358839,288445,928386,508251,637700,162525,26096,415524,983332,500306,200080,517494,740506,494991,193676,234647,302912,14180,679029,15029,962902,282961,498487,591592,917792,781223,63901,964312,897511,960213,223858,927867,993244,483230,696330,730530,893587,634876,730042,347998,661704,330557,286095,52207,914010,729316,801509,50334,738537,727466,519719,346963,168644,19328,617311,1042057,332002,4911,540560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]