SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101911 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101911 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010869,388449,629730,266779,304916,788025,377148,319361,363509,999250,191321,26238,721678,363750,664545,401108,285566,543921,907890,861240,987466,303428,277704,213024,1032496,933333,296879,267340,150658,937353,77667,419519,421428,524134,900773,805015,851685,39322,769824,571551,738001,812575,16380,237487,691650,312581,166252,1031400,984016,482545,1017879,342238,677868,954266,72777,676941,904449,458623,500554,655982) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]