SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003509 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003509 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522421,820341,331241,10697,642539,827725,929716,440672,122545,150884,853669,1010917,250223,540895,417413,179200,68578,716820,1006247,150053,689669,894593,191841,282484,318652,552201,673395,188696,343460,874989,310343,329643,490945,409588,99020,788025,690132,432746,135118,385465,78507,852083,103546,718728,267965,899014,342650,852748,822581,466843,643095,447724,30625,777193,678425,360395,485559,121950,160035,238770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001896s ]