SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023481 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023481 [ RunTime:0.002297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621289,155391,686349,875022,327238,286247,392628,359649,314956,248518,488540,909124,50222,920354,637690,996145,873033,458543,812081,78024,275055,276564,846890,290274,925251,609293,940371,459391,699744,759968,765691,944311,951290,550071,837752,875264,539896,109570,214548,713445,159931,707226,295255,388557,387946,916437,490708,376384,684658,100208,778391,724786,121178,561930,785367,485203,867570,379449,793742,372164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]