SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029807 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029807 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (372809,8690,971998,362972,65454,195282,951193,444976,919772,899850,362511,191888,800160,126545,978514,285969,437607,393458,498847,572034,82594,923317,969033,846954,30918,386311,893761,87260,982258,112635,1048491,756018,193067,934775,1003717,341230,40870,870426,447577,366689,695432,234330,680175,90887,429632,364314,567937,166080,1008313,886179,943798,149393,937170,257042,301434,121130,389819,498422,774687,427915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000788s ]