SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103988 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103988 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39009,221013,548316,452006,44721,327499,575353,1037206,923110,463031,660544,395687,607324,969131,590273,968213,362347,851262,840518,821214,281107,263051,210931,1002718,1013385,286272,154937,818470,131868,588690,389093,460137,652638,375824,213130,953621,750618,543252,796037,898755,844461,719845,752768,807191,1048097,396364,1023618,606206,279469,758100,375251,653404,735399,513030,642936,87078,365377,442429,302692,76021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]