SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544952 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544952 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553013,629863,9423,905296,455600,1020898,794174,891434,424799,741300,141367,697897,804820,312702,36600,1002547,996602,660497,74448,131980,225896,161871,503483,406600,751610,779376,291716,453610,822468,685258,969435,247375,512771,125732,285812,4065,603483,847443,177918,878779,515342,191971,282627,62310,56023,71682,909741,729599,159429,431789,295772,729213,576763,108045,898730,133090,432979,416993,222704,352371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]