SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404202 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404202 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211048,142317,138602,694023,682400,729679,861159,498475,338331,886552,242397,85292,350925,775156,912596,723499,325862,101184,230027,60151,413295,465077,472883,346661,11043,572205,988011,845633,620515,871459,288726,482142,742102,244805,503103,742611,117711,145588,830023,915704,421821,664148,976401,642939,334483,367465,172744,810857,437127,357418,796700,76430,666581,617972,340842,673144,827639,821656,1032727,458237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001279s ]