SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480439 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480439 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187606,643254,155366,504091,877669,68675,128328,846036,810079,757277,224752,144713,10109,466508,102748,1014412,362889,366912,458379,837895,160899,333618,867856,381718,52356,523779,182113,467045,74675,906033,531222,258960,731047,669338,457032,254584,651059,350723,785093,386788,673139,951160,761420,252645,131573,872511,56542,469800,410030,860115,583349,485334,1001513,976235,446365,188229,68174,838936,190731,788166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000819s ]