SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447493 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447493 [ RunTime:0.003839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696059,189092,396154,971678,835247,966983,725218,702405,330712,885197,407233,46828,4743,786656,500494,986670,626938,396825,162037,944057,279054,818506,178728,468038,143941,718408,128849,119300,376721,421352,327313,28793,901241,59155,146517,304387,294390,764647,1002793,709464,483932,865914,494267,575189,951281,805287,861647,651946,115140,315895,127949,591403,309294,86081,506165,622763,802565,958974,593806,110353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000402s ]