SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118651 LIMIT 1 [ RunTime:0.003018s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118651 [ RunTime:0.008975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040132,334481,115813,201021,925404,649212,410120,609919,139212,124367,879850,868481,856766,574789,7520,430983,245291,1004892,926747,944135,16637,549192,280934,919424,398405,874712,231291,330101,61116,317022,960138,932737,459822,409196,68392,801599,148,547475,255964,1001044,431237,680265,90860,169812,460042,609913,621471,511521,739055,632778,597439,986977,662536,973382,332893,626635,909684,582238,801786,683950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001766s ]