SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412313 LIMIT 1 [ RunTime:0.000774s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412313 [ RunTime:0.002593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205455,710113,824051,39093,207051,276540,485277,234834,361767,9552,330840,323769,461162,75465,729859,648692,2159,409164,662718,199444,672665,149199,502200,687065,265310,791049,654829,211616,410213,739570,521947,711917,832902,91384,893716,814314,100504,51603,6192,366170,919863,995560,579085,129655,690686,1035355,679462,140731,838888,983195,622172,786212,414455,595419,101964,113332,657254,547989,357699,643181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000799s ]