SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036910 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036910 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239282,350466,452707,403562,379853,1042228,594022,191445,140861,302577,989571,1035703,651126,168937,296675,995846,325743,207011,66546,833554,621980,704483,615709,515935,88465,655493,362472,554835,594498,289385,403372,442765,635887,978184,600390,688777,512988,115637,318748,698066,514685,421421,876887,12632,507654,529894,943797,589862,720223,658636,478123,377916,795426,449633,268007,780398,427577,959550,450118,323990) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000921s ]