SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003643s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411128 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411128 [ RunTime:0.002267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281244,40416,729263,428393,1025805,107346,192892,392685,998474,569819,115569,289478,325513,148289,104106,216202,101030,641911,277809,206120,380108,450619,634056,768280,1010560,171639,620144,579601,1018358,719374,485483,11114,642946,140434,925859,346529,1030440,123471,59206,873777,644177,530683,1032423,439587,1019042,689975,939662,651861,397513,613917,704864,235183,174810,417584,784374,803812,278611,581259,26751,461143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000749s ]