SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003038s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532318 LIMIT 1 [ RunTime:0.003316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532318 [ RunTime:0.003595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34489,25099,396435,927762,328868,956204,36259,398988,307583,603972,220286,34303,366421,526733,144733,129995,568891,235265,431917,770757,512941,416469,516627,433777,164715,664020,174340,12749,919164,362637,1002334,528593,374272,881027,374726,392867,514929,795058,536892,64539,406755,995758,1401,335512,317849,572443,523263,207020,130593,40586,567435,907886,163036,364145,837032,469908,217631,885998,729660,102373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]