SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502378 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502378 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339635,745272,166375,349394,413213,396199,759664,213846,65577,550711,943628,653307,159307,355683,176474,566324,954785,492253,1034108,430886,883864,378815,351662,689320,876912,152406,70567,330706,180595,801653,2037,791241,539341,694233,979453,970157,856641,76125,187848,724517,562413,59272,304358,697321,130775,918770,566340,894402,502252,103502,324184,632216,808929,256029,896177,643269,1033276,622365,877206,570912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]