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` = 1039701 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039701 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580687,735887,118547,496692,980223,463199,441274,329885,106129,673073,546322,506853,270188,232444,423721,164089,727428,595953,619521,674380,431745,828690,772263,68993,844844,349842,1009972,969316,675972,660872,1036494,366280,735206,137804,128138,635581,275566,16957,888135,594876,1048026,525455,83836,908860,740686,401726,826724,532024,263254,589862,980922,134713,214983,1650,403542,909689,23257,115947,595164,477368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]