SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197450 LIMIT 1 [ RunTime:0.001172s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197450 [ RunTime:0.003252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459220,34806,396465,497255,695369,988129,830557,450807,161948,982431,241282,856976,789020,142449,312489,431102,702472,538861,29133,672921,940207,174856,540079,291676,94787,502446,300638,38918,447568,480916,684035,343609,819666,489612,855706,614510,497589,677141,201473,476792,271067,834495,461792,243019,14213,767754,234388,355863,470217,576718,345980,521670,311059,260682,690435,244601,545659,757795,241100,203941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001111s ]