SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 670318 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 670318 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896134,313569,885328,166678,253506,58776,880977,657460,990609,526923,1005710,614276,793954,402650,671617,445886,194027,737705,14147,865981,780475,449802,844764,313230,332497,944832,663926,32681,91439,681213,521758,878980,824569,125312,722867,525804,856543,457378,128158,979361,884191,507285,1046158,335908,712609,709866,492139,480827,938345,930813,398542,745376,6923,238658,572077,474519,564154,683515,44587,579217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 670318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 670318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]