SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399478 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399478 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127272,1021075,121593,633174,397605,245110,991028,173389,859589,697106,462261,783564,765287,252053,733164,427321,1033939,592376,756156,184461,310968,14109,347026,570062,273986,258773,773543,353891,167499,536565,930113,622410,484925,346897,742414,820012,506906,713601,137226,153672,138479,1023608,529434,188847,569568,551050,917799,49279,1045472,327449,181278,536380,831515,439462,1014857,389970,1861,795231,90300,633733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]