SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98670 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98670 [ RunTime:0.005200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731480,1022429,1028153,962688,154661,808223,284178,17547,321353,442356,165662,576605,261166,98455,239467,36427,22273,301840,846869,445738,756749,955878,1037968,599315,287377,536167,756390,937267,536571,775487,541901,506948,940224,533417,197110,170729,281991,735244,836092,908865,480298,1029957,699337,1039625,919941,172539,187745,211132,846128,782029,367770,512012,116062,279629,295481,1032432,957238,131671,788448,440753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]