SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048101 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048101 [ RunTime:0.003949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491127,668378,368878,29599,686345,15664,400079,19065,25060,979844,297820,429601,925875,463224,707350,405416,950028,409763,188212,362968,969080,573783,195670,965515,278195,74460,307578,374967,453772,168140,262482,1044233,585748,826835,17455,867959,906088,231140,622455,521145,892691,85501,801535,142138,994434,641693,719673,924481,787573,134439,862971,177922,330790,618918,289610,762388,73394,988866,524856,447063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]