SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322812 LIMIT 1 [ RunTime:0.000697s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322812 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773716,949954,201468,987282,656864,789199,876445,948993,70746,71933,805395,389863,193852,629802,281912,492952,744415,318213,315408,629006,368137,371338,124535,332071,746634,336170,185798,285357,871851,131413,463166,402497,580127,939800,946259,391185,15955,897438,66032,282313,754006,219116,404103,461370,7185,997974,487615,506603,651925,945543,1004929,130668,269687,600350,266666,93917,961410,632580,252211,244151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000989s ]