SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003083 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003083 [ RunTime:0.002863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450067,447549,947043,1016707,130176,179510,767760,991020,511364,559741,461883,151016,721755,843174,824015,336694,330585,909177,141704,786692,353089,212317,837594,1028888,129658,637837,251569,605744,78212,361016,595601,1042886,493139,531982,69182,391479,9828,571728,865488,429258,285186,18038,704281,870113,476098,513357,227005,399209,995050,856910,401422,915503,1028170,500568,395196,172213,107807,358950,536768,98953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]