SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105467 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105467 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012081,175337,509099,200558,1028763,570786,498900,372972,514094,113873,242164,535454,1024828,230626,211102,171807,845251,625707,39513,609755,951015,80997,762899,59247,368164,214176,421795,107707,575891,955462,570233,127733,127217,860866,190044,277396,509185,506324,749908,517140,407155,244638,427041,755774,902015,1041503,299717,647926,867266,1036024,707438,1029119,535103,220124,508320,293861,734916,145051,48049,556611) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105467 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105467 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]