SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415083 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415083 [ RunTime:0.002637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147910,478812,402825,579765,577824,32386,143496,405022,490492,51963,141238,321762,25826,367437,604094,65713,993556,599193,103101,475711,709532,789200,151094,786571,412305,863763,331380,996151,551878,612596,652844,438063,864520,865924,303026,729260,761105,176725,69939,647994,864132,997053,879968,216503,538113,507287,1041804,826827,491085,899954,920656,502606,90905,601959,295265,450855,617352,50196,379130,787336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001290s ]