SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001839s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201642 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201642 [ RunTime:0.004502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21473,702914,73649,744774,207377,490425,520875,784343,281280,994830,522571,695020,136541,26369,39515,96715,749691,291296,755588,718561,151682,611533,202775,628721,943599,964668,1006144,262770,650524,44306,486633,144131,547712,1006767,917742,806954,717289,425964,770612,412101,145740,137638,597177,529420,30014,124687,939931,903092,837211,67359,140549,282029,191921,202439,904314,331376,655255,738171,802947,528978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201642 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201642 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]