SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534096 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534096 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556884,323456,916339,315001,556887,1032109,126098,601250,210384,769464,904404,126549,185319,890140,394662,126064,656454,519753,242166,474986,353334,748979,135371,459332,213170,535609,922098,522956,955572,301954,148428,790505,946510,150691,1021327,944149,491578,585403,382174,566458,959371,395831,1035234,756213,626909,595963,72667,589008,551490,368377,1030286,400426,189025,367935,203880,943481,607656,877505,326174,723810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003215s ]