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` = 392019 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392019 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59561,572086,435960,484891,644874,257166,708226,167282,386423,5717,720763,306381,783667,794884,726680,693266,873667,243820,728197,140525,493189,499796,948596,904983,80676,369996,606710,1014008,488046,437294,483175,166270,793378,456073,966016,862435,644217,917665,844549,503280,735030,876497,779777,957952,696702,485651,507187,60764,718891,405543,787394,642153,695505,77712,553808,783016,789445,664405,220084,714088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]