SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570113 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570113 [ RunTime:0.005534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27703,110278,939790,682201,260549,117906,655531,105762,102955,226972,103134,172287,692569,980478,403203,918929,145732,382850,644384,105341,755398,651154,900509,867664,100700,958039,786823,812233,397752,30321,166359,450072,88282,170246,442295,285419,885481,556132,710408,731517,12685,189077,247043,713539,339119,328178,751977,416353,209743,126370,474941,389902,209564,697123,242619,592116,951507,390730,111656,303779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]