SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039118 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039118 [ RunTime:0.004151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407714,640931,149381,212817,675802,871270,779863,974614,560910,850632,266327,349560,416211,871049,478049,750692,615447,207516,137772,342782,502584,210148,634608,96049,690830,782813,892569,562540,44710,589099,21450,4326,741948,640580,69006,541545,395820,732191,197329,935258,455510,51004,358701,559941,290534,685488,908853,502679,1031925,1016402,797298,353915,181079,397837,999043,530360,836523,711190,749369,150123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]