SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264931 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264931 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250536,416021,385782,250150,11799,341020,539704,420823,606669,509177,904182,188469,845728,406192,762874,602121,538986,318960,637728,634298,1037845,666396,821753,710899,576014,857432,793258,865176,970270,992022,521558,500181,920331,45973,453364,936180,241301,792445,572203,460175,162799,270913,766139,97486,947721,575857,362118,653096,472396,320764,124746,102943,146860,785906,856075,604103,1023647,908056,266077,118180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]