SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451283 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451283 [ RunTime:0.002850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992323,478514,291542,106181,409469,150393,218648,392889,208206,615768,909508,195773,154210,161141,870593,466591,701686,649981,454663,122663,518975,577393,311253,633474,605390,664534,595100,774829,988972,80679,926128,768536,479874,95966,85891,381054,84960,240161,305507,551122,635858,145004,773184,307796,25328,555799,775976,853285,677,460465,30011,141001,816213,303675,255669,82399,399891,25818,1048759,814627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]