SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003912 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003912 [ RunTime:0.001439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349540,642662,289975,341085,963881,584289,820340,1001988,718046,455140,103818,204131,991484,276437,753774,561438,296728,781600,785893,570930,1017460,341665,805507,79353,699874,236402,843859,290409,647914,1038390,317765,1044954,874330,894880,332669,165702,1011181,616805,404835,16042,622168,487005,179519,516871,911374,570329,971180,397406,216383,577225,408740,475548,343817,615160,630858,61257,98850,582909,990593,702935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]